package com.iss.okair.db.mapper;

import com.iss.okair.db.entity.AssetsCar;
import com.iss.okair.db.entity.AssetsFinance;
import com.iss.okair.db.entity.Assetstrans;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;


public interface AssetstransMapper {

    @Insert("INSERT INTO assetstrans VALUES(#{id},#{assetsid},#{batchno},#{transtype},#{count},#{price},#{handleremp},#{instocktime},#{targetemp},#{comment},NOW(),#{createuser})")
    int add(Assetstrans tran);
    @Select("select assetsCode FROM assets_car where id=#{id}")
    AssetsCar instocks(@Param("id") String id);
}
